

export ORACLE_SID=siga
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH

ALTER PLUGGABLE DATABASE siga OPEN;
ALTER SESSION SET CONTAINER = siga;


SELECT username,account_status,expiry_date,created
FROM sys.user$ u JOIN dba_users d ON u.name = d.username WHERE d.username LIKE 'SIGA%' OR d.username IN ('SYSTEM', 'SYS') ORDER BY username;

CREATE USER admin_siga IDENTIFIED BY "SigaAdmin2026*" DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;